Release 10.1A: OpenEdge Development:
Progress Dynamics Repository Reference

Table description

This table acts as a global audit file to record modifications to data. The audit can be turned on by defining a category of audit for an entity type. It can be turned off again by resetting the active flag on a category.

Table 18–1 lists the table’s FLA, fields, and foreign keys.

Table 18–1: gst_audit table information 

Table FLA	Fields (data type)	Foreign keys
gstad	audit_obj (Decimal) owning_entity_mnemonic (Character) owning_reference (Character) owning_obj (Decimal) audit_date (Date) audit_time (Integer) audit_user_obj (Decimal) program_name (Character) program_procedure (Character) audit_action (Character) old_detail (Character)	None

Table 18–2 gives details of the table’s indexes.

Table 18–2: gst_audit index information 

Index name	Elements	Type
XPKgst_audit	audit_obj	Primary Unique
XIE1gst_audit	owning_entity_mnemonic owning_reference audit_date audit_time	Nonunique
XIE2gst_audit	owning_reference audit_date audit_time	Nonunique
XIE3gst_audit	audit_user_obj audit_date audit_time	Nonunique

The audit holds the following information:

Basic details on the action (create, amend, or delete).
The user who performed the action.
The date and time of the action.
The program and procedure that performed the action.

The audit might also hold a record of the data before the update. The audit can be used to keep old values of fields by defining more categories, such as one for each field or group of fields on an entity.